Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 27312 |
| Missing cells | 94165 |
| Missing cells (%) | 16.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.2 MiB |
| Average record size in memory | 161.0 B |
Variable types
| Numeric | 6 |
|---|---|
| DateTime | 2 |
| Categorical | 11 |
| Boolean | 1 |
| Text | 1 |
BORO is highly overall correlated with Latitude and 4 other fields | High correlation |
INCIDENT_KEY is highly overall correlated with LOC_CLASSFCTN_DESC and 1 other fields | High correlation |
JURISDICTION_CODE is highly overall correlated with LOCATION_DESC and 1 other fields | High correlation |
LOCATION_DESC is highly overall correlated with JURISDICTION_CODE and 1 other fields | High correlation |
LOC_CLASSFCTN_DESC is highly overall correlated with INCIDENT_KEY and 3 other fields | High correlation |
LOC_OF_OCCUR_DESC is highly overall correlated with INCIDENT_KEY and 1 other fields | High correlation |
Latitude is highly overall correlated with BORO and 2 other fields | High correlation |
Longitude is highly overall correlated with BORO and 1 other fields | High correlation |
PERP_AGE_GROUP is highly overall correlated with PERP_SEX | High correlation |
PERP_RACE is highly overall correlated with PERP_SEX | High correlation |
PERP_SEX is highly overall correlated with PERP_AGE_GROUP and 1 other fields | High correlation |
PRECINCT is highly overall correlated with BORO and 2 other fields | High correlation |
X_COORD_CD is highly overall correlated with BORO and 1 other fields | High correlation |
Y_COORD_CD is highly overall correlated with BORO and 2 other fields | High correlation |
JURISDICTION_CODE is highly imbalanced (58.0%) | Imbalance |
PERP_SEX is highly imbalanced (60.6%) | Imbalance |
VIC_SEX is highly imbalanced (71.0%) | Imbalance |
VIC_RACE is highly imbalanced (52.5%) | Imbalance |
LOC_OF_OCCUR_DESC has 25596 (93.7%) missing values | Missing |
LOC_CLASSFCTN_DESC has 25596 (93.7%) missing values | Missing |
LOCATION_DESC has 14977 (54.8%) missing values | Missing |
PERP_AGE_GROUP has 9344 (34.2%) missing values | Missing |
PERP_SEX has 9310 (34.1%) missing values | Missing |
PERP_RACE has 9310 (34.1%) missing values | Missing |
Reproduction
| Analysis started | 2025-05-28 16:31:48.611369 |
|---|---|
| Analysis finished | 2025-05-28 16:32:02.149235 |
| Duration | 13.54 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
INCIDENT_KEY
Real number (ℝ)
High correlation 
| Distinct | 21420 |
|---|---|
| Distinct (%) | 78.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2086054 × 108 |
| Minimum | 9953245 |
|---|---|
| Maximum | 2.6119019 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 213.5 KiB |
Quantile statistics
| Minimum | 9953245 |
|---|---|
| 5-th percentile | 24224969 |
| Q1 | 63860880 |
| median | 90372218 |
| Q3 | 1.8881023 × 108 |
| 95-th percentile | 2.4266957 × 108 |
| Maximum | 2.6119019 × 108 |
| Range | 2.5123694 × 108 |
| Interquartile range (IQR) | 1.2494935 × 108 |
Descriptive statistics
| Standard deviation | 73412859 |
|---|---|
| Coefficient of variation (CV) | 0.60741795 |
| Kurtosis | -1.2470904 |
| Mean | 1.2086054 × 108 |
| Median Absolute Deviation (MAD) | 55642069 |
| Skewness | 0.34508435 |
| Sum | 3.300943 × 1012 |
| Variance | 5.3894478 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 173354054 | 18 | 0.1% |
| 94424905 | 12 | < 0.1% |
| 23749375 | 12 | < 0.1% |
| 138997051 | 12 | < 0.1% |
| 215776333 | 12 | < 0.1% |
| 212640102 | 12 | < 0.1% |
| 72195829 | 12 | < 0.1% |
| 24717013 | 12 | < 0.1% |
| 79378503 | 12 | < 0.1% |
| 33706902 | 12 | < 0.1% |
| Other values (21410) | 27186 |
| Value | Count | Frequency (%) |
| 9953245 | 1 | |
| 9953246 | 1 | |
| 9953247 | 1 | |
| 9953248 | 1 | |
| 9953249 | 1 | |
| 9953250 | 2 | |
| 9953252 | 1 | |
| 9953255 | 2 | |
| 9953257 | 1 | |
| 9953258 | 1 |
| Value | Count | Frequency (%) |
| 261190187 | 1 | < 0.1% |
| 261176930 | 1 | < 0.1% |
| 261176929 | 1 | < 0.1% |
| 261175635 | 1 | < 0.1% |
| 261160236 | 1 | < 0.1% |
| 261120108 | 2 | |
| 261120017 | 1 | < 0.1% |
| 260637443 | 4 | |
| 260637442 | 1 | < 0.1% |
| 260531774 | 1 | < 0.1% |
OCCUR_DATE
Date
| Distinct | 5761 |
|---|---|
| Distinct (%) | 21.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 213.5 KiB |
| Minimum | 2006-01-01 00:00:00 |
|---|---|
| Maximum | 2022-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
OCCUR_TIME
Date
| Distinct | 1421 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 213.5 KiB |
| Minimum | 2025-05-28 00:00:00 |
|---|---|
| Maximum | 2025-05-28 23:59:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
BORO
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 213.5 KiB |
| BROOKLYN | |
|---|---|
| BRONX | |
| QUEENS | |
| MANHATTAN | |
| STATEN ISLAND | 776 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 7.1012376 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | QUEENS |
|---|---|
| 2nd row | BRONX |
| 3rd row | QUEENS |
| 4th row | BRONX |
| 5th row | BRONX |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 10933 | |
| BRONX | 7937 | |
| QUEENS | 4094 | 15.0% |
| MANHATTAN | 3572 | 13.1% |
| STATEN ISLAND | 776 | 2.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 10933 | |
| bronx | 7937 | |
| queens | 4094 | 14.6% |
| manhattan | 3572 | 12.7% |
| staten | 776 | 2.8% |
| island | 776 | 2.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 31660 | |
| O | 29803 | |
| B | 18870 | |
| R | 18870 | |
| A | 12268 | 6.3% |
| L | 11709 | 6.0% |
| K | 10933 | 5.6% |
| Y | 10933 | 5.6% |
| E | 8964 | 4.6% |
| T | 8696 | 4.5% |
| Other values (9) | 31243 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 193173 | |
| Space Separator | 776 | 0.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 31660 | |
| O | 29803 | |
| B | 18870 | |
| R | 18870 | |
| A | 12268 | 6.4% |
| L | 11709 | 6.1% |
| K | 10933 | 5.7% |
| Y | 10933 | 5.7% |
| E | 8964 | 4.6% |
| T | 8696 | 4.5% |
| Other values (8) | 30467 |
Space Separator
| Value | Count | Frequency (%) |
| 776 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 193173 | |
| Common | 776 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 31660 | |
| O | 29803 | |
| B | 18870 | |
| R | 18870 | |
| A | 12268 | 6.4% |
| L | 11709 | 6.1% |
| K | 10933 | 5.7% |
| Y | 10933 | 5.7% |
| E | 8964 | 4.6% |
| T | 8696 | 4.5% |
| Other values (8) | 30467 |
Common
| Value | Count | Frequency (%) |
| 776 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 193949 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 31660 | |
| O | 29803 | |
| B | 18870 | |
| R | 18870 | |
| A | 12268 | 6.3% |
| L | 11709 | 6.0% |
| K | 10933 | 5.6% |
| Y | 10933 | 5.6% |
| E | 8964 | 4.6% |
| T | 8696 | 4.5% |
| Other values (9) | 31243 |
LOC_OF_OCCUR_DESC
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 25596 |
| Missing (%) | 93.7% |
| Memory size | 213.5 KiB |
| OUTSIDE | |
|---|---|
| INSIDE |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.8589744 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | OUTSIDE |
|---|---|
| 2nd row | OUTSIDE |
| 3rd row | OUTSIDE |
| 4th row | OUTSIDE |
| 5th row | OUTSIDE |
Common Values
| Value | Count | Frequency (%) |
| OUTSIDE | 1474 | 5.4% |
| INSIDE | 242 | 0.9% |
| (Missing) | 25596 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| outside | 1474 | |
| inside | 242 | 14.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 1958 | |
| S | 1716 | |
| D | 1716 | |
| E | 1716 | |
| T | 1474 | |
| U | 1474 | |
| O | 1474 | |
| N | 242 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11770 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 1958 | |
| S | 1716 | |
| D | 1716 | |
| E | 1716 | |
| T | 1474 | |
| U | 1474 | |
| O | 1474 | |
| N | 242 | 2.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11770 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 1958 | |
| S | 1716 | |
| D | 1716 | |
| E | 1716 | |
| T | 1474 | |
| U | 1474 | |
| O | 1474 | |
| N | 242 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11770 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 1958 | |
| S | 1716 | |
| D | 1716 | |
| E | 1716 | |
| T | 1474 | |
| U | 1474 | |
| O | 1474 | |
| N | 242 | 2.1% |
PRECINCT
Real number (ℝ)
High correlation 
| Distinct | 77 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 65.635362 |
| Minimum | 1 |
|---|---|
| Maximum | 123 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 213.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 44 |
| median | 68 |
| Q3 | 81 |
| 95-th percentile | 113 |
| Maximum | 123 |
| Range | 122 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 27.305705 |
|---|---|
| Coefficient of variation (CV) | 0.41602125 |
| Kurtosis | -0.73292236 |
| Mean | 65.635362 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.21090762 |
| Sum | 1792633 |
| Variance | 745.60154 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 75 | 1557 | 5.7% |
| 73 | 1452 | 5.3% |
| 67 | 1216 | 4.5% |
| 44 | 1020 | 3.7% |
| 79 | 1012 | 3.7% |
| 47 | 953 | 3.5% |
| 40 | 908 | 3.3% |
| 46 | 895 | 3.3% |
| 42 | 850 | 3.1% |
| 113 | 802 | 2.9% |
| Other values (67) | 16647 |
| Value | Count | Frequency (%) |
| 1 | 25 | 0.1% |
| 5 | 58 | |
| 6 | 28 | 0.1% |
| 7 | 109 | |
| 9 | 109 | |
| 10 | 73 | |
| 13 | 60 | |
| 14 | 56 | |
| 17 | 10 | < 0.1% |
| 18 | 34 | 0.1% |
| Value | Count | Frequency (%) |
| 123 | 31 | 0.1% |
| 122 | 61 | 0.2% |
| 121 | 112 | 0.4% |
| 120 | 572 | |
| 115 | 179 | 0.7% |
| 114 | 369 | |
| 113 | 802 | |
| 112 | 23 | 0.1% |
| 111 | 11 | < 0.1% |
| 110 | 160 | 0.6% |
JURISDICTION_CODE
Categorical
High correlation  Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 213.5 KiB |
| 0.0 | |
|---|---|
| 2.0 | |
| 1.0 | 74 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 22809 | |
| 2.0 | 4427 | 16.2% |
| 1.0 | 74 | 0.3% |
| (Missing) | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 22809 | |
| 2.0 | 4427 | 16.2% |
| 1.0 | 74 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 50119 | |
| . | 27310 | |
| 2 | 4427 | 5.4% |
| 1 | 74 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 54620 | |
| Other Punctuation | 27310 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 50119 | |
| 2 | 4427 | 8.1% |
| 1 | 74 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 27310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 81930 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 50119 | |
| . | 27310 | |
| 2 | 4427 | 5.4% |
| 1 | 74 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 81930 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 50119 | |
| . | 27310 | |
| 2 | 4427 | 5.4% |
| 1 | 74 | 0.1% |
LOC_CLASSFCTN_DESC
Categorical
High correlation  Missing 
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 25596 |
| Missing (%) | 93.7% |
| Memory size | 213.5 KiB |
| STREET | |
|---|---|
| HOUSING | |
| DWELLING | |
| COMMERCIAL | 100 |
| OTHER | 31 |
| Other values (4) | 75 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.6386946 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STREET |
|---|---|
| 2nd row | STREET |
| 3rd row | STREET |
| 4th row | STREET |
| 5th row | STREET |
Common Values
| Value | Count | Frequency (%) |
| STREET | 1103 | 4.0% |
| HOUSING | 280 | 1.0% |
| DWELLING | 127 | 0.5% |
| COMMERCIAL | 100 | 0.4% |
| OTHER | 31 | 0.1% |
| PLAYGROUND | 30 | 0.1% |
| VEHICLE | 23 | 0.1% |
| TRANSIT | 15 | 0.1% |
| PARKING LOT | 7 | < 0.1% |
| (Missing) | 25596 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| street | 1103 | |
| housing | 280 | 16.3% |
| dwelling | 127 | 7.4% |
| commercial | 100 | 5.8% |
| other | 31 | 1.8% |
| playground | 30 | 1.7% |
| vehicle | 23 | 1.3% |
| transit | 15 | 0.9% |
| parking | 7 | 0.4% |
| lot | 7 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2510 | |
| T | 2274 | |
| S | 1398 | |
| R | 1286 | |
| I | 552 | 4.8% |
| N | 459 | 4.0% |
| O | 448 | 3.9% |
| G | 444 | 3.9% |
| L | 414 | 3.6% |
| H | 334 | 2.9% |
| Other values (11) | 1273 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11385 | |
| Space Separator | 7 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2510 | |
| T | 2274 | |
| S | 1398 | |
| R | 1286 | |
| I | 552 | 4.8% |
| N | 459 | 4.0% |
| O | 448 | 3.9% |
| G | 444 | 3.9% |
| L | 414 | 3.6% |
| H | 334 | 2.9% |
| Other values (10) | 1266 |
Space Separator
| Value | Count | Frequency (%) |
| 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11385 | |
| Common | 7 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2510 | |
| T | 2274 | |
| S | 1398 | |
| R | 1286 | |
| I | 552 | 4.8% |
| N | 459 | 4.0% |
| O | 448 | 3.9% |
| G | 444 | 3.9% |
| L | 414 | 3.6% |
| H | 334 | 2.9% |
| Other values (10) | 1266 |
Common
| Value | Count | Frequency (%) |
| 7 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 2510 | |
| T | 2274 | |
| S | 1398 | |
| R | 1286 | |
| I | 552 | 4.8% |
| N | 459 | 4.0% |
| O | 448 | 3.9% |
| G | 444 | 3.9% |
| L | 414 | 3.6% |
| H | 334 | 2.9% |
| Other values (11) | 1273 |
LOCATION_DESC
Categorical
High correlation  Missing 
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 14977 |
| Missing (%) | 54.8% |
| Memory size | 213.5 KiB |
| MULTI DWELL - PUBLIC HOUS | |
|---|---|
| MULTI DWELL - APT BUILD | |
| (null) | |
| PVT HOUSE | |
| GROCERY/BODEGA | |
| Other values (35) |
Length
| Max length | 25 |
|---|---|
| Median length | 23 |
| Mean length | 19.263802 |
| Min length | 3 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | MULTI DWELL - APT BUILD |
|---|---|
| 2nd row | MULTI DWELL - PUBLIC HOUS |
| 3rd row | GROCERY/BODEGA |
| 4th row | MULTI DWELL - PUBLIC HOUS |
| 5th row | MULTI DWELL - PUBLIC HOUS |
Common Values
| Value | Count | Frequency (%) |
| MULTI DWELL - PUBLIC HOUS | 4832 | 17.7% |
| MULTI DWELL - APT BUILD | 2835 | 10.4% |
| (null) | 977 | 3.6% |
| PVT HOUSE | 951 | 3.5% |
| GROCERY/BODEGA | 694 | 2.5% |
| BAR/NIGHT CLUB | 628 | 2.3% |
| COMMERCIAL BLDG | 292 | 1.1% |
| RESTAURANT/DINER | 204 | 0.7% |
| NONE | 175 | 0.6% |
| BEAUTY/NAIL SALON | 112 | 0.4% |
| Other values (30) | 635 | 2.3% |
| (Missing) | 14977 |
Length
| Value | Count | Frequency (%) |
| multi | 7667 | |
| dwell | 7667 | |
| 7667 | ||
| public | 4832 | |
| hous | 4832 | |
| apt | 2835 | 6.2% |
| build | 2835 | 6.2% |
| null | 977 | 2.1% |
| pvt | 951 | 2.1% |
| house | 951 | 2.1% |
| Other values (50) | 4344 |
Most occurring characters
| Value | Count | Frequency (%) |
| 33223 | ||
| L | 32783 | |
| U | 22312 | 9.4% |
| I | 17099 | 7.2% |
| T | 13357 | 5.6% |
| D | 11934 | 5.0% |
| E | 11525 | 4.9% |
| B | 10110 | 4.3% |
| P | 8788 | 3.7% |
| O | 8669 | 3.6% |
| Other values (23) | 67819 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 189067 | |
| Space Separator | 33223 | 14.0% |
| Dash Punctuation | 7667 | 3.2% |
| Lowercase Letter | 3908 | 1.6% |
| Other Punctuation | 1800 | 0.8% |
| Open Punctuation | 977 | 0.4% |
| Close Punctuation | 977 | 0.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 32783 | |
| U | 22312 | |
| I | 17099 | 9.0% |
| T | 13357 | 7.1% |
| D | 11934 | 6.3% |
| E | 11525 | 6.1% |
| B | 10110 | 5.3% |
| P | 8788 | 4.6% |
| O | 8669 | 4.6% |
| M | 8408 | 4.4% |
| Other values (14) | 44082 |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1954 | |
| u | 977 | |
| n | 977 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1789 | |
| . | 11 | 0.6% |
Space Separator
| Value | Count | Frequency (%) |
| 33223 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7667 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 977 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 977 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 192975 | |
| Common | 44644 | 18.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 32783 | |
| U | 22312 | |
| I | 17099 | 8.9% |
| T | 13357 | 6.9% |
| D | 11934 | 6.2% |
| E | 11525 | 6.0% |
| B | 10110 | 5.2% |
| P | 8788 | 4.6% |
| O | 8669 | 4.5% |
| M | 8408 | 4.4% |
| Other values (17) | 47990 |
Common
| Value | Count | Frequency (%) |
| 33223 | ||
| - | 7667 | 17.2% |
| / | 1789 | 4.0% |
| ( | 977 | 2.2% |
| ) | 977 | 2.2% |
| . | 11 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 237619 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 33223 | ||
| L | 32783 | |
| U | 22312 | 9.4% |
| I | 17099 | 7.2% |
| T | 13357 | 5.6% |
| D | 11934 | 5.0% |
| E | 11525 | 4.9% |
| B | 10110 | 4.3% |
| P | 8788 | 3.7% |
| O | 8669 | 3.6% |
| Other values (23) | 67819 |
STATISTICAL_MURDER_FLAG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.8 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 22046 | |
| True | 5266 | 19.3% |
PERP_AGE_GROUP
Categorical
High correlation  Missing 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 9344 |
| Missing (%) | 34.2% |
| Memory size | 213.5 KiB |
| 18-24 | |
|---|---|
| 25-44 | |
| UNKNOWN | |
| <18 | |
| (null) | |
| Other values (5) |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.2019702 |
| Min length | 3 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 25-44 |
|---|---|
| 2nd row | 25-44 |
| 3rd row | 25-44 |
| 4th row | UNKNOWN |
| 5th row | UNKNOWN |
Common Values
| Value | Count | Frequency (%) |
| 18-24 | 6222 | |
| 25-44 | 5687 | |
| UNKNOWN | 3148 | 11.5% |
| <18 | 1591 | 5.8% |
| (null) | 640 | 2.3% |
| 45-64 | 617 | 2.3% |
| 65+ | 60 | 0.2% |
| 940 | 1 | < 0.1% |
| 224 | 1 | < 0.1% |
| 1020 | 1 | < 0.1% |
| (Missing) | 9344 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 18-24 | 6222 | |
| 25-44 | 5687 | |
| unknown | 3148 | |
| 18 | 1591 | 8.9% |
| null | 640 | 3.6% |
| 45-64 | 617 | 3.4% |
| 65 | 60 | 0.3% |
| 940 | 1 | < 0.1% |
| 224 | 1 | < 0.1% |
| 1020 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 18832 | |
| - | 12526 | |
| 2 | 11912 | |
| N | 9444 | |
| 1 | 7814 | |
| 8 | 7813 | |
| 5 | 6364 | 6.8% |
| U | 3148 | 3.4% |
| K | 3148 | 3.4% |
| O | 3148 | 3.4% |
| Other values (11) | 9320 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 53416 | |
| Uppercase Letter | 22036 | |
| Dash Punctuation | 12526 | 13.4% |
| Lowercase Letter | 2560 | 2.7% |
| Math Symbol | 1651 | 1.8% |
| Open Punctuation | 640 | 0.7% |
| Close Punctuation | 640 | 0.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 18832 | |
| 2 | 11912 | |
| 1 | 7814 | |
| 8 | 7813 | |
| 5 | 6364 | 11.9% |
| 6 | 677 | 1.3% |
| 0 | 3 | < 0.1% |
| 9 | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 9444 | |
| U | 3148 | 14.3% |
| K | 3148 | 14.3% |
| O | 3148 | 14.3% |
| W | 3148 | 14.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1280 | |
| u | 640 | |
| n | 640 |
Math Symbol
| Value | Count | Frequency (%) |
| < | 1591 | |
| + | 60 | 3.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12526 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 640 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 640 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 68873 | |
| Latin | 24596 | 26.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 18832 | |
| - | 12526 | |
| 2 | 11912 | |
| 1 | 7814 | |
| 8 | 7813 | |
| 5 | 6364 | 9.2% |
| < | 1591 | 2.3% |
| 6 | 677 | 1.0% |
| ( | 640 | 0.9% |
| ) | 640 | 0.9% |
| Other values (3) | 64 | 0.1% |
Latin
| Value | Count | Frequency (%) |
| N | 9444 | |
| U | 3148 | 12.8% |
| K | 3148 | 12.8% |
| O | 3148 | 12.8% |
| W | 3148 | 12.8% |
| l | 1280 | 5.2% |
| u | 640 | 2.6% |
| n | 640 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 93469 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 18832 | |
| - | 12526 | |
| 2 | 11912 | |
| N | 9444 | |
| 1 | 7814 | |
| 8 | 7813 | |
| 5 | 6364 | 6.8% |
| U | 3148 | 3.4% |
| K | 3148 | 3.4% |
| O | 3148 | 3.4% |
| Other values (11) | 9320 |
PERP_SEX
Categorical
High correlation  Imbalance  Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9310 |
| Missing (%) | 34.1% |
| Memory size | 213.5 KiB |
| M | |
|---|---|
| U | 1499 |
| (null) | 640 |
| F | 424 |
Length
| Max length | 6 |
|---|---|
| Median length | 1 |
| Mean length | 1.177758 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | U |
| 5th row | U |
Common Values
| Value | Count | Frequency (%) |
| M | 15439 | |
| U | 1499 | 5.5% |
| (null) | 640 | 2.3% |
| F | 424 | 1.6% |
| (Missing) | 9310 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 15439 | |
| u | 1499 | 8.3% |
| null | 640 | 3.6% |
| f | 424 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 15439 | |
| U | 1499 | 7.1% |
| l | 1280 | 6.0% |
| ( | 640 | 3.0% |
| n | 640 | 3.0% |
| u | 640 | 3.0% |
| ) | 640 | 3.0% |
| F | 424 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 17362 | |
| Lowercase Letter | 2560 | 12.1% |
| Open Punctuation | 640 | 3.0% |
| Close Punctuation | 640 | 3.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 15439 | |
| U | 1499 | 8.6% |
| F | 424 | 2.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1280 | |
| n | 640 | |
| u | 640 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 640 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 640 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19922 | |
| Common | 1280 | 6.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 15439 | |
| U | 1499 | 7.5% |
| l | 1280 | 6.4% |
| n | 640 | 3.2% |
| u | 640 | 3.2% |
| F | 424 | 2.1% |
Common
| Value | Count | Frequency (%) |
| ( | 640 | |
| ) | 640 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21202 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 15439 | |
| U | 1499 | 7.1% |
| l | 1280 | 6.0% |
| ( | 640 | 3.0% |
| n | 640 | 3.0% |
| u | 640 | 3.0% |
| ) | 640 | 3.0% |
| F | 424 | 2.0% |
PERP_RACE
Categorical
High correlation  Missing 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9310 |
| Missing (%) | 34.1% |
| Memory size | 213.5 KiB |
| BLACK | |
|---|---|
| WHITE HISPANIC | |
| UNKNOWN | |
| BLACK HISPANIC | |
| (null) | 640 |
| Other values (3) | 439 |
Length
| Max length | 30 |
|---|---|
| Median length | 5 |
| Mean length | 7.2321409 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BLACK |
|---|---|
| 2nd row | BLACK |
| 3rd row | BLACK |
| 4th row | UNKNOWN |
| 5th row | UNKNOWN |
Common Values
| Value | Count | Frequency (%) |
| BLACK | 11432 | |
| WHITE HISPANIC | 2341 | 8.6% |
| UNKNOWN | 1836 | 6.7% |
| BLACK HISPANIC | 1314 | 4.8% |
| (null) | 640 | 2.3% |
| WHITE | 283 | 1.0% |
| ASIAN / PACIFIC ISLANDER | 154 | 0.6% |
| AMERICAN INDIAN/ALASKAN NATIVE | 2 | < 0.1% |
| (Missing) | 9310 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| black | 12746 | |
| hispanic | 3655 | 16.5% |
| white | 2624 | 11.9% |
| unknown | 1836 | 8.3% |
| null | 640 | 2.9% |
| asian | 154 | 0.7% |
| 154 | 0.7% | |
| pacific | 154 | 0.7% |
| islander | 154 | 0.7% |
| american | 2 | < 0.1% |
| Other values (2) | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 17031 | |
| C | 16711 | |
| K | 14584 | |
| L | 12902 | |
| B | 12746 | |
| I | 10558 | |
| N | 9481 | |
| H | 6279 | 4.8% |
| W | 4460 | 3.4% |
| 4121 | 3.2% | |
| Other values (17) | 21320 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 122076 | |
| Space Separator | 4121 | 3.2% |
| Lowercase Letter | 2560 | 2.0% |
| Open Punctuation | 640 | 0.5% |
| Close Punctuation | 640 | 0.5% |
| Other Punctuation | 156 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 17031 | |
| C | 16711 | |
| K | 14584 | |
| L | 12902 | |
| B | 12746 | |
| I | 10558 | |
| N | 9481 | |
| H | 6279 | 5.1% |
| W | 4460 | 3.7% |
| S | 3965 | 3.2% |
| Other values (10) | 13359 |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1280 | |
| n | 640 | |
| u | 640 |
Space Separator
| Value | Count | Frequency (%) |
| 4121 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 640 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 640 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 156 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 124636 | |
| Common | 5557 | 4.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 17031 | |
| C | 16711 | |
| K | 14584 | |
| L | 12902 | |
| B | 12746 | |
| I | 10558 | |
| N | 9481 | |
| H | 6279 | 5.0% |
| W | 4460 | 3.6% |
| S | 3965 | 3.2% |
| Other values (13) | 15919 |
Common
| Value | Count | Frequency (%) |
| 4121 | ||
| ( | 640 | 11.5% |
| ) | 640 | 11.5% |
| / | 156 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 130193 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 17031 | |
| C | 16711 | |
| K | 14584 | |
| L | 12902 | |
| B | 12746 | |
| I | 10558 | |
| N | 9481 | |
| H | 6279 | 4.8% |
| W | 4460 | 3.4% |
| 4121 | 3.2% | |
| Other values (17) | 21320 |
VIC_AGE_GROUP
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 213.5 KiB |
| 25-44 | |
|---|---|
| 18-24 | |
| <18 | |
| 45-64 | |
| 65+ | 181 |
| Other values (2) | 62 |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 4.7832821 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 18-24 |
|---|---|
| 2nd row | 18-24 |
| 3rd row | 25-44 |
| 4th row | <18 |
| 5th row | 45-64 |
Common Values
| Value | Count | Frequency (%) |
| 25-44 | 12281 | |
| 18-24 | 10086 | |
| <18 | 2839 | 10.4% |
| 45-64 | 1863 | 6.8% |
| 65+ | 181 | 0.7% |
| UNKNOWN | 61 | 0.2% |
| 1022 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 25-44 | 12281 | |
| 18-24 | 10086 | |
| 18 | 2839 | 10.4% |
| 45-64 | 1863 | 6.8% |
| 65 | 181 | 0.7% |
| unknown | 61 | 0.2% |
| 1022 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 38374 | |
| - | 24230 | |
| 2 | 22369 | |
| 5 | 14325 | 11.0% |
| 1 | 12926 | 9.9% |
| 8 | 12925 | 9.9% |
| < | 2839 | 2.2% |
| 6 | 2044 | 1.6% |
| N | 183 | 0.1% |
| + | 181 | 0.1% |
| Other values (5) | 245 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 102964 | |
| Dash Punctuation | 24230 | 18.5% |
| Math Symbol | 3020 | 2.3% |
| Uppercase Letter | 427 | 0.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 38374 | |
| 2 | 22369 | |
| 5 | 14325 | 13.9% |
| 1 | 12926 | 12.6% |
| 8 | 12925 | 12.6% |
| 6 | 2044 | 2.0% |
| 0 | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 183 | |
| U | 61 | 14.3% |
| K | 61 | 14.3% |
| O | 61 | 14.3% |
| W | 61 | 14.3% |
Math Symbol
| Value | Count | Frequency (%) |
| < | 2839 | |
| + | 181 | 6.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 24230 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 130214 | |
| Latin | 427 | 0.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 38374 | |
| - | 24230 | |
| 2 | 22369 | |
| 5 | 14325 | 11.0% |
| 1 | 12926 | 9.9% |
| 8 | 12925 | 9.9% |
| < | 2839 | 2.2% |
| 6 | 2044 | 1.6% |
| + | 181 | 0.1% |
| 0 | 1 | < 0.1% |
Latin
| Value | Count | Frequency (%) |
| N | 183 | |
| U | 61 | 14.3% |
| K | 61 | 14.3% |
| O | 61 | 14.3% |
| W | 61 | 14.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 130641 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 38374 | |
| - | 24230 | |
| 2 | 22369 | |
| 5 | 14325 | 11.0% |
| 1 | 12926 | 9.9% |
| 8 | 12925 | 9.9% |
| < | 2839 | 2.2% |
| 6 | 2044 | 1.6% |
| N | 183 | 0.1% |
| + | 181 | 0.1% |
| Other values (5) | 245 | 0.2% |
VIC_SEX
Categorical
Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 213.5 KiB |
| M | |
|---|---|
| F | |
| U | 11 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 24686 | |
| F | 2615 | 9.6% |
| U | 11 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 24686 | |
| f | 2615 | 9.6% |
| u | 11 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 24686 | |
| F | 2615 | 9.6% |
| U | 11 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 27312 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 24686 | |
| F | 2615 | 9.6% |
| U | 11 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27312 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 24686 | |
| F | 2615 | 9.6% |
| U | 11 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27312 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 24686 | |
| F | 2615 | 9.6% |
| U | 11 | < 0.1% |
VIC_RACE
Categorical
Imbalance 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 213.5 KiB |
| BLACK | |
|---|---|
| WHITE HISPANIC | |
| BLACK HISPANIC | |
| WHITE | 698 |
| ASIAN / PACIFIC ISLANDER | 404 |
| Other values (2) | 76 |
Length
| Max length | 30 |
|---|---|
| Median length | 5 |
| Mean length | 7.5012083 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BLACK |
|---|---|
| 2nd row | BLACK |
| 3rd row | WHITE |
| 4th row | WHITE HISPANIC |
| 5th row | BLACK |
Common Values
| Value | Count | Frequency (%) |
| BLACK | 19439 | |
| WHITE HISPANIC | 4049 | 14.8% |
| BLACK HISPANIC | 2646 | 9.7% |
| WHITE | 698 | 2.6% |
| ASIAN / PACIFIC ISLANDER | 404 | 1.5% |
| UNKNOWN | 66 | 0.2% |
| AMERICAN INDIAN/ALASKAN NATIVE | 10 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| black | 22085 | |
| hispanic | 6695 | 19.0% |
| white | 4747 | 13.5% |
| asian | 404 | 1.1% |
| 404 | 1.1% | |
| pacific | 404 | 1.1% |
| islander | 404 | 1.1% |
| unknown | 66 | 0.2% |
| american | 10 | < 0.1% |
| indian/alaskan | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 30466 | |
| C | 29598 | |
| L | 22499 | |
| K | 22161 | |
| B | 22085 | |
| I | 19793 | |
| H | 11442 | 5.6% |
| 7927 | 3.9% | |
| N | 7751 | 3.8% |
| S | 7513 | 3.7% |
| Other values (12) | 23638 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 196532 | |
| Space Separator | 7927 | 3.9% |
| Other Punctuation | 414 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 30466 | |
| C | 29598 | |
| L | 22499 | |
| K | 22161 | |
| B | 22085 | |
| I | 19793 | |
| H | 11442 | 5.8% |
| N | 7751 | 3.9% |
| S | 7513 | 3.8% |
| P | 7099 | 3.6% |
| Other values (10) | 16125 |
Space Separator
| Value | Count | Frequency (%) |
| 7927 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 414 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 196532 | |
| Common | 8341 | 4.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 30466 | |
| C | 29598 | |
| L | 22499 | |
| K | 22161 | |
| B | 22085 | |
| I | 19793 | |
| H | 11442 | 5.8% |
| N | 7751 | 3.9% |
| S | 7513 | 3.8% |
| P | 7099 | 3.6% |
| Other values (10) | 16125 |
Common
| Value | Count | Frequency (%) |
| 7927 | ||
| / | 414 | 5.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 204873 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 30466 | |
| C | 29598 | |
| L | 22499 | |
| K | 22161 | |
| B | 22085 | |
| I | 19793 | |
| H | 11442 | 5.6% |
| 7927 | 3.9% | |
| N | 7751 | 3.8% |
| S | 7513 | 3.7% |
| Other values (12) | 23638 |
X_COORD_CD
Real number (ℝ)
High correlation 
| Distinct | 12088 |
|---|---|
| Distinct (%) | 44.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1009448.7 |
| Minimum | 914928.06 |
|---|---|
| Maximum | 1066815.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 213.5 KiB |
Quantile statistics
| Minimum | 914928.06 |
|---|---|
| 5-th percentile | 985316.88 |
| Q1 | 1000028.5 |
| median | 1007730.7 |
| Q3 | 1016838 |
| 95-th percentile | 1046384.1 |
| Maximum | 1066815.4 |
| Range | 151887.31 |
| Interquartile range (IQR) | 16809.469 |
Descriptive statistics
| Standard deviation | 18377.826 |
|---|---|
| Coefficient of variation (CV) | 0.018205805 |
| Kurtosis | 2.4771539 |
| Mean | 1009448.7 |
| Median Absolute Deviation (MAD) | 8096.7188 |
| Skewness | -0.11683797 |
| Sum | 2.7570062 × 1010 |
| Variance | 3.3774448 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1017119.438 | 66 | 0.2% |
| 1026387 | 47 | 0.2% |
| 1008276 | 47 | 0.2% |
| 936721.6875 | 44 | 0.2% |
| 1017141 | 44 | 0.2% |
| 1006434 | 42 | 0.2% |
| 1046405 | 41 | 0.2% |
| 1008427.438 | 40 | 0.1% |
| 998032 | 39 | 0.1% |
| 1046367 | 37 | 0.1% |
| Other values (12078) | 26865 |
| Value | Count | Frequency (%) |
| 914928.0625 | 1 | |
| 920262.5625 | 1 | |
| 920515.3125 | 1 | |
| 922416.3125 | 1 | |
| 922884.1875 | 1 | |
| 925479.75 | 1 | |
| 926453.875 | 1 | |
| 926731 | 1 | |
| 927599.375 | 1 | |
| 929510 | 1 |
| Value | Count | Frequency (%) |
| 1066815.375 | 1 | < 0.1% |
| 1066516.5 | 4 | |
| 1065539.625 | 2 | |
| 1065473.75 | 1 | < 0.1% |
| 1063056 | 1 | < 0.1% |
| 1062381 | 1 | < 0.1% |
| 1061286.375 | 1 | < 0.1% |
| 1060126.375 | 1 | < 0.1% |
| 1059864.875 | 1 | < 0.1% |
| 1059828 | 1 | < 0.1% |
Y_COORD_CD
Real number (ℝ)
High correlation 
| Distinct | 12283 |
|---|---|
| Distinct (%) | 45.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208127.4 |
| Minimum | 125756.72 |
|---|---|
| Maximum | 271127.69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 213.5 KiB |
Quantile statistics
| Minimum | 125756.72 |
|---|---|
| 5-th percentile | 162476 |
| Q1 | 182834.34 |
| median | 194486.57 |
| Q3 | 239518.47 |
| 95-th percentile | 256184.25 |
| Maximum | 271127.69 |
| Range | 145370.97 |
| Interquartile range (IQR) | 56684.133 |
Descriptive statistics
| Standard deviation | 31886.378 |
|---|---|
| Coefficient of variation (CV) | 0.15320605 |
| Kurtosis | -1.3627973 |
| Mean | 208127.4 |
| Median Absolute Deviation (MAD) | 22944.477 |
| Skewness | 0.1665039 |
| Sum | 5.6843756 × 109 |
| Variance | 1.0167411 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 183909.3438 | 66 | 0.2% |
| 183623 | 47 | 0.2% |
| 262634 | 47 | 0.2% |
| 172119.4375 | 44 | 0.2% |
| 183798 | 44 | 0.2% |
| 244344 | 42 | 0.2% |
| 187112.6406 | 41 | 0.2% |
| 183517.7188 | 40 | 0.1% |
| 175598 | 38 | 0.1% |
| 186986 | 37 | 0.1% |
| Other values (12273) | 26866 |
| Value | Count | Frequency (%) |
| 125756.7188 | 1 | < 0.1% |
| 127539 | 1 | < 0.1% |
| 128875.4141 | 1 | < 0.1% |
| 129721 | 1 | < 0.1% |
| 130418.4922 | 1 | < 0.1% |
| 131549 | 1 | < 0.1% |
| 132099.3438 | 1 | < 0.1% |
| 134246.7656 | 4 | |
| 134459 | 1 | < 0.1% |
| 135831.5156 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 271127.6875 | 2 | < 0.1% |
| 269635 | 4 | |
| 269534 | 1 | < 0.1% |
| 269204.8438 | 4 | |
| 269204 | 1 | < 0.1% |
| 269168.625 | 4 | |
| 269115.625 | 7 | |
| 269040 | 1 | < 0.1% |
| 268978 | 1 | < 0.1% |
| 268961 | 1 | < 0.1% |
Latitude
Real number (ℝ)
High correlation 
| Distinct | 12619 |
|---|---|
| Distinct (%) | 46.2% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.737892 |
| Minimum | 40.511586 |
|---|---|
| Maximum | 40.910818 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 213.5 KiB |
Quantile statistics
| Minimum | 40.511586 |
|---|---|
| 5-th percentile | 40.612606 |
| Q1 | 40.668481 |
| median | 40.700318 |
| Q3 | 40.824067 |
| 95-th percentile | 40.869836 |
| Maximum | 40.910818 |
| Range | 0.39923252 |
| Interquartile range (IQR) | 0.15558556 |
Descriptive statistics
| Standard deviation | 0.08752512 |
|---|---|
| Coefficient of variation (CV) | 0.0021484941 |
| Kurtosis | -1.3631852 |
| Mean | 40.737892 |
| Median Absolute Deviation (MAD) | 0.062822439 |
| Skewness | 0.16654804 |
| Sum | 1112225.9 |
| Variance | 0.0076606466 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.67141261 | 66 | 0.2% |
| 40.67065507 | 47 | 0.2% |
| 40.88745131 | 47 | 0.2% |
| 40.67110691 | 44 | 0.2% |
| 40.63898538 | 44 | 0.2% |
| 40.83732351 | 42 | 0.2% |
| 40.68004774 | 41 | 0.2% |
| 40.67036569 | 40 | 0.1% |
| 40.64865009 | 38 | 0.1% |
| 40.67970041 | 37 | 0.1% |
| Other values (12609) | 26856 |
| Value | Count | Frequency (%) |
| 40.51158557 | 1 | < 0.1% |
| 40.516572 | 1 | < 0.1% |
| 40.52018586 | 1 | < 0.1% |
| 40.52258031 | 1 | < 0.1% |
| 40.52443658 | 1 | < 0.1% |
| 40.527587 | 1 | < 0.1% |
| 40.52910801 | 1 | < 0.1% |
| 40.53500878 | 4 | |
| 40.535616 | 1 | < 0.1% |
| 40.53929753 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.91081809 | 2 | < 0.1% |
| 40.90666838 | 4 | |
| 40.90639492 | 1 | < 0.1% |
| 40.90548733 | 4 | |
| 40.905479 | 1 | < 0.1% |
| 40.90538927 | 4 | |
| 40.90523864 | 7 | |
| 40.90503636 | 1 | < 0.1% |
| 40.904861 | 1 | < 0.1% |
| 40.9048145 | 1 | < 0.1% |
Longitude
Real number (ℝ)
High correlation 
| Distinct | 12607 |
|---|---|
| Distinct (%) | 46.2% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.909051 |
| Minimum | -74.249303 |
|---|---|
| Maximum | -73.702046 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 27302 |
| Negative (%) | > 99.9% |
| Memory size | 213.5 KiB |
Quantile statistics
| Minimum | -74.249303 |
|---|---|
| 5-th percentile | -73.996196 |
| Q1 | -73.943027 |
| median | -73.915221 |
| Q3 | -73.88233 |
| 95-th percentile | -73.775916 |
| Maximum | -73.702046 |
| Range | 0.54725733 |
| Interquartile range (IQR) | 0.060697446 |
Descriptive statistics
| Standard deviation | 0.066272257 |
|---|---|
| Coefficient of variation (CV) | -0.00089667309 |
| Kurtosis | 2.4669825 |
| Mean | -73.909051 |
| Median Absolute Deviation (MAD) | 0.029296094 |
| Skewness | -0.11919338 |
| Sum | -2017864.9 |
| Variance | 0.0043920121 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.88151014 | 66 | 0.2% |
| -73.84760779 | 47 | 0.2% |
| -73.91339092 | 47 | 0.2% |
| -73.88143296 | 44 | 0.2% |
| -74.17125343 | 44 | 0.2% |
| -73.91983076 | 42 | 0.2% |
| -73.7759092 | 41 | 0.2% |
| -73.91284539 | 40 | 0.1% |
| -73.95033556 | 38 | 0.1% |
| -73.77604737 | 37 | 0.1% |
| Other values (12597) | 26856 |
| Value | Count | Frequency (%) |
| -74.2493035 | 1 | |
| -74.23014863 | 1 | |
| -74.22932911 | 1 | |
| -74.22241624 | 1 | |
| -74.22078238 | 1 | |
| -74.21146347 | 1 | |
| -74.2079657 | 1 | |
| -74.20699897 | 1 | |
| -74.20383785 | 1 | |
| -74.196874 | 1 |
| Value | Count | Frequency (%) |
| -73.70204617 | 1 | < 0.1% |
| -73.70308024 | 4 | |
| -73.70659811 | 2 | |
| -73.70686575 | 1 | < 0.1% |
| -73.71563826 | 1 | < 0.1% |
| -73.71803289 | 1 | < 0.1% |
| -73.72199603 | 1 | < 0.1% |
| -73.72653339 | 1 | < 0.1% |
| -73.72739037 | 1 | < 0.1% |
| -73.727478 | 1 | < 0.1% |
Lon_Lat
Text
| Distinct | 12645 |
|---|---|
| Distinct (%) | 46.3% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Memory size | 213.5 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 44 |
| Mean length | 43.270676 |
| Min length | 24 |
Unique
| Unique | 7665 ? |
|---|---|
| Unique (%) | 28.1% |
Sample
| 1st row | POINT (-73.73083868899994 40.662964620000025) |
|---|---|
| 2nd row | POINT (-73.92494232599995 40.81035186300006) |
| 3rd row | POINT (-73.91549174199997 40.74260663300004) |
| 4th row | POINT (-73.91945661499994 40.83778200300003) |
| 5th row | POINT (-73.85290950899997 40.88623791800006) |
| Value | Count | Frequency (%) |
| point | 27302 | |
| 73.88151014499994 | 66 | 0.1% |
| 40.67141260500006 | 66 | 0.1% |
| 73.84760778699996 | 47 | 0.1% |
| 40.670655072000045 | 47 | 0.1% |
| 73.91339091999998 | 47 | 0.1% |
| 40.88745131300004 | 47 | 0.1% |
| 40.67110691100004 | 44 | 0.1% |
| 73.88143295699996 | 44 | 0.1% |
| 74.17125343299995 | 44 | 0.1% |
| Other values (25238) | 54152 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 173561 | |
| 9 | 162366 | |
| 7 | 85042 | 7.2% |
| 4 | 82827 | 7.0% |
| 3 | 74639 | 6.3% |
| 8 | 67516 | 5.7% |
| 6 | 67117 | 5.7% |
| 5 | 55260 | 4.7% |
| 54604 | 4.6% | |
| . | 54604 | 4.6% |
| Other values (10) | 303840 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 853752 | |
| Uppercase Letter | 136510 | 11.6% |
| Space Separator | 54604 | 4.6% |
| Other Punctuation | 54604 | 4.6% |
| Open Punctuation | 27302 | 2.3% |
| Dash Punctuation | 27302 | 2.3% |
| Close Punctuation | 27302 | 2.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 173561 | |
| 9 | 162366 | |
| 7 | 85042 | |
| 4 | 82827 | |
| 3 | 74639 | |
| 8 | 67516 | 7.9% |
| 6 | 67117 | 7.9% |
| 5 | 55260 | 6.5% |
| 1 | 42924 | 5.0% |
| 2 | 42500 | 5.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 27302 | |
| I | 27302 | |
| O | 27302 | |
| P | 27302 | |
| T | 27302 |
Space Separator
| Value | Count | Frequency (%) |
| 54604 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 54604 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 27302 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 27302 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 27302 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1044866 | |
| Latin | 136510 | 11.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 173561 | |
| 9 | 162366 | |
| 7 | 85042 | |
| 4 | 82827 | |
| 3 | 74639 | |
| 8 | 67516 | 6.5% |
| 6 | 67117 | 6.4% |
| 5 | 55260 | 5.3% |
| 54604 | 5.2% | |
| . | 54604 | 5.2% |
| Other values (5) | 167330 |
Latin
| Value | Count | Frequency (%) |
| N | 27302 | |
| I | 27302 | |
| O | 27302 | |
| P | 27302 | |
| T | 27302 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1181376 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 173561 | |
| 9 | 162366 | |
| 7 | 85042 | 7.2% |
| 4 | 82827 | 7.0% |
| 3 | 74639 | 6.3% |
| 8 | 67516 | 5.7% |
| 6 | 67117 | 5.7% |
| 5 | 55260 | 4.7% |
| 54604 | 4.6% | |
| . | 54604 | 4.6% |
| Other values (10) | 303840 |
Interactions
Correlations
| BORO | INCIDENT_KEY | JURISDICTION_CODE | LOCATION_DESC | LOC_CLASSFCTN_DESC | LOC_OF_OCCUR_DESC | Latitude | Longitude | PERP_AGE_GROUP | PERP_RACE | PERP_SEX | PRECINCT | STATISTICAL_MURDER_FLAG | VIC_AGE_GROUP | VIC_RACE | VIC_SEX | X_COORD_CD | Y_COORD_CD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BORO | 1.000 | 0.037 | 0.077 | 0.162 | 0.116 | 0.084 | 0.603 | 0.717 | 0.047 | 0.135 | 0.033 | 0.890 | 0.013 | 0.023 | 0.149 | 0.011 | 0.717 | 0.603 |
| INCIDENT_KEY | 0.037 | 1.000 | 0.046 | 0.287 | 1.000 | 1.000 | 0.034 | 0.011 | 0.258 | 0.242 | 0.365 | -0.035 | 0.017 | 0.060 | 0.037 | 0.017 | 0.011 | 0.034 |
| JURISDICTION_CODE | 0.077 | 0.046 | 1.000 | 0.637 | 0.927 | 0.150 | 0.128 | 0.116 | 0.052 | 0.060 | 0.000 | 0.141 | 0.034 | 0.033 | 0.069 | 0.000 | 0.114 | 0.127 |
| LOCATION_DESC | 0.162 | 0.287 | 0.637 | 1.000 | 0.520 | 0.460 | 0.125 | 0.122 | 0.164 | 0.178 | 0.246 | 0.136 | 0.137 | 0.076 | 0.129 | 0.048 | 0.122 | 0.125 |
| LOC_CLASSFCTN_DESC | 0.116 | 1.000 | 0.927 | 0.520 | 1.000 | 0.641 | 0.122 | 0.136 | 0.139 | 0.094 | 0.131 | 0.102 | 0.202 | 0.062 | 0.115 | 0.082 | 0.134 | 0.121 |
| LOC_OF_OCCUR_DESC | 0.084 | 1.000 | 0.150 | 0.460 | 0.641 | 1.000 | 0.099 | 0.058 | 0.190 | 0.085 | 0.058 | 0.055 | 0.097 | 0.084 | 0.033 | 0.086 | 0.062 | 0.094 |
| Latitude | 0.603 | 0.034 | 0.128 | 0.125 | 0.122 | 0.099 | 1.000 | 0.262 | 0.036 | 0.139 | 0.035 | -0.556 | 0.020 | 0.031 | 0.157 | 0.022 | 0.260 | 1.000 |
| Longitude | 0.717 | 0.011 | 0.116 | 0.122 | 0.136 | 0.058 | 0.262 | 1.000 | 0.036 | 0.099 | 0.024 | 0.184 | 0.023 | 0.033 | 0.110 | 0.006 | 1.000 | 0.262 |
| PERP_AGE_GROUP | 0.047 | 0.258 | 0.052 | 0.164 | 0.139 | 0.190 | 0.036 | 0.036 | 1.000 | 0.456 | 0.683 | 0.037 | 0.214 | 0.155 | 0.060 | 0.072 | 0.036 | 0.036 |
| PERP_RACE | 0.135 | 0.242 | 0.060 | 0.178 | 0.094 | 0.085 | 0.139 | 0.099 | 0.456 | 1.000 | 0.770 | 0.107 | 0.133 | 0.049 | 0.244 | 0.031 | 0.099 | 0.139 |
| PERP_SEX | 0.033 | 0.365 | 0.000 | 0.246 | 0.131 | 0.058 | 0.035 | 0.024 | 0.683 | 0.770 | 1.000 | 0.035 | 0.101 | 0.049 | 0.038 | 0.030 | 0.024 | 0.035 |
| PRECINCT | 0.890 | -0.035 | 0.141 | 0.136 | 0.102 | 0.055 | -0.556 | 0.184 | 0.037 | 0.107 | 0.035 | 1.000 | 0.015 | 0.026 | 0.130 | 0.020 | 0.185 | -0.556 |
| STATISTICAL_MURDER_FLAG | 0.013 | 0.017 | 0.034 | 0.137 | 0.202 | 0.097 | 0.020 | 0.023 | 0.214 | 0.133 | 0.101 | 0.015 | 1.000 | 0.089 | 0.048 | 0.005 | 0.024 | 0.019 |
| VIC_AGE_GROUP | 0.023 | 0.060 | 0.033 | 0.076 | 0.062 | 0.084 | 0.031 | 0.033 | 0.155 | 0.049 | 0.049 | 0.026 | 0.089 | 1.000 | 0.119 | 0.161 | 0.033 | 0.031 |
| VIC_RACE | 0.149 | 0.037 | 0.069 | 0.129 | 0.115 | 0.033 | 0.157 | 0.110 | 0.060 | 0.244 | 0.038 | 0.130 | 0.048 | 0.119 | 1.000 | 0.186 | 0.109 | 0.156 |
| VIC_SEX | 0.011 | 0.017 | 0.000 | 0.048 | 0.082 | 0.086 | 0.022 | 0.006 | 0.072 | 0.031 | 0.030 | 0.020 | 0.005 | 0.161 | 0.186 | 1.000 | 0.007 | 0.022 |
| X_COORD_CD | 0.717 | 0.011 | 0.114 | 0.122 | 0.134 | 0.062 | 0.260 | 1.000 | 0.036 | 0.099 | 0.024 | 0.185 | 0.024 | 0.033 | 0.109 | 0.007 | 1.000 | 0.261 |
| Y_COORD_CD | 0.603 | 0.034 | 0.127 | 0.125 | 0.121 | 0.094 | 1.000 | 0.262 | 0.036 | 0.139 | 0.035 | -0.556 | 0.019 | 0.031 | 0.156 | 0.022 | 0.261 | 1.000 |
Missing values
Sample
| INCIDENT_KEY | OCCUR_DATE | OCCUR_TIME | BORO | LOC_OF_OCCUR_DESC | PRECINCT | JURISDICTION_CODE | LOC_CLASSFCTN_DESC | LOCATION_DESC | STATISTICAL_MURDER_FLAG | PERP_AGE_GROUP | PERP_SEX | PERP_RACE | VIC_AGE_GROUP | VIC_SEX | VIC_RACE | X_COORD_CD | Y_COORD_CD | Latitude | Longitude | Lon_Lat | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 228798151 | 05/27/2021 | 21:30:00 | QUEENS | NaN | 105 | 0.0 | NaN | NaN | False | NaN | NaN | NaN | 18-24 | M | BLACK | 1.058925e+06 | 180924.000000 | 40.662965 | -73.730839 | POINT (-73.73083868899994 40.662964620000025) |
| 1 | 137471050 | 06/27/2014 | 17:40:00 | BRONX | NaN | 40 | 0.0 | NaN | NaN | False | NaN | NaN | NaN | 18-24 | M | BLACK | 1.005028e+06 | 234516.000000 | 40.810352 | -73.924942 | POINT (-73.92494232599995 40.81035186300006) |
| 2 | 147998800 | 11/21/2015 | 03:56:00 | QUEENS | NaN | 108 | 0.0 | NaN | NaN | True | NaN | NaN | NaN | 25-44 | M | WHITE | 1.007668e+06 | 209836.531250 | 40.742607 | -73.915492 | POINT (-73.91549174199997 40.74260663300004) |
| 3 | 146837977 | 10/09/2015 | 18:30:00 | BRONX | NaN | 44 | 0.0 | NaN | NaN | False | NaN | NaN | NaN | <18 | M | WHITE HISPANIC | 1.006537e+06 | 244511.140625 | 40.837782 | -73.919457 | POINT (-73.91945661499994 40.83778200300003) |
| 4 | 58921844 | 02/19/2009 | 22:58:00 | BRONX | NaN | 47 | 0.0 | NaN | NaN | True | 25-44 | M | BLACK | 45-64 | M | BLACK | 1.024922e+06 | 262189.406250 | 40.886238 | -73.852910 | POINT (-73.85290950899997 40.88623791800006) |
| 5 | 219559682 | 10/21/2020 | 21:36:00 | BROOKLYN | NaN | 81 | 0.0 | NaN | NaN | True | NaN | NaN | NaN | 25-44 | M | BLACK | 1.004234e+06 | 186461.703125 | 40.678457 | -73.927952 | POINT (-73.92795224099996 40.678456718000064) |
| 6 | 85295722 | 06/17/2012 | 22:47:00 | QUEENS | NaN | 114 | 0.0 | NaN | NaN | False | NaN | NaN | NaN | 25-44 | M | BLACK | 9.988600e+05 | 214885.000000 | 40.756482 | -73.947266 | POINT (-73.94726649399996 40.75648234300007) |
| 7 | 71662474 | 03/08/2010 | 19:41:00 | BROOKLYN | NaN | 81 | 0.0 | NaN | NaN | True | NaN | NaN | NaN | 18-24 | M | BLACK | 1.002883e+06 | 192219.703125 | 40.694264 | -73.932809 | POINT (-73.93280863699994 40.694264056000065) |
| 8 | 83002139 | 02/05/2012 | 05:45:00 | QUEENS | NaN | 105 | 0.0 | NaN | NaN | False | NaN | NaN | NaN | 25-44 | M | BLACK | 1.054366e+06 | 196628.406250 | 40.706107 | -73.747107 | POINT (-73.74710653899996 40.706106731000034) |
| 9 | 86437261 | 08/26/2012 | 01:10:00 | QUEENS | NaN | 101 | 0.0 | NaN | MULTI DWELL - APT BUILD | False | 25-44 | M | BLACK | 25-44 | M | BLACK | 1.053937e+06 | 157130.421875 | 40.597697 | -73.749065 | POINT (-73.74906464199995 40.59769719800005) |
| INCIDENT_KEY | OCCUR_DATE | OCCUR_TIME | BORO | LOC_OF_OCCUR_DESC | PRECINCT | JURISDICTION_CODE | LOC_CLASSFCTN_DESC | LOCATION_DESC | STATISTICAL_MURDER_FLAG | PERP_AGE_GROUP | PERP_SEX | PERP_RACE | VIC_AGE_GROUP | VIC_SEX | VIC_RACE | X_COORD_CD | Y_COORD_CD | Latitude | Longitude | Lon_Lat | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27302 | 243566423 | 04/12/2022 | 19:43:00 | BRONX | OUTSIDE | 48 | 0.0 | STREET | (null) | False | 18-24 | M | BLACK | 45-64 | M | BLACK | 1016397.0 | 247394.0 | 40.845658 | -73.883806 | POINT (-73.883806 40.845658) |
| 27303 | 249978889 | 08/23/2022 | 01:58:00 | BROOKLYN | OUTSIDE | 88 | 0.0 | STREET | (null) | False | 25-44 | M | BLACK | <18 | M | BLACK | 991912.0 | 191839.0 | 40.693229 | -73.972367 | POINT (-73.972367 40.693229) |
| 27304 | 246999028 | 06/22/2022 | 05:28:00 | BRONX | OUTSIDE | 41 | 0.0 | STREET | (null) | False | 25-44 | M | BLACK | 25-44 | M | BLACK | 1015533.0 | 238047.0 | 40.820006 | -73.886973 | POINT (-73.886973 40.820006) |
| 27305 | 248475917 | 07/23/2022 | 15:03:00 | QUEENS | OUTSIDE | 110 | 0.0 | STREET | (null) | False | 45-64 | M | WHITE HISPANIC | 25-44 | M | BLACK HISPANIC | 1022651.0 | 212300.0 | 40.749308 | -73.861406 | POINT (-73.86140607 40.74930759) |
| 27306 | 245173597 | 05/16/2022 | 16:50:00 | BRONX | OUTSIDE | 41 | 0.0 | STREET | BEAUTY/NAIL SALON | True | 18-24 | M | BLACK | <18 | F | WHITE HISPANIC | 1012932.0 | 238907.0 | 40.822374 | -73.896369 | POINT (-73.896369 40.822374) |
| 27307 | 245029823 | 05/14/2022 | 03:02:00 | BRONX | OUTSIDE | 48 | 0.0 | STREET | (null) | False | (null) | (null) | (null) | 18-24 | M | BLACK | 1011526.0 | 247828.0 | 40.846864 | -73.901413 | POINT (-73.90141321 40.84686352) |
| 27308 | 239583450 | 01/22/2022 | 13:15:00 | MANHATTAN | OUTSIDE | 30 | 0.0 | STREET | (null) | False | 25-44 | F | WHITE HISPANIC | 25-44 | M | WHITE HISPANIC | 997458.0 | 240485.0 | 40.826743 | -73.952273 | POINT (-73.952273 40.826743) |
| 27309 | 246825728 | 06/18/2022 | 03:29:00 | MANHATTAN | OUTSIDE | 32 | 0.0 | STREET | (null) | False | 18-24 | M | BLACK | 25-44 | M | BLACK | 1000999.0 | 234464.0 | 40.810209 | -73.939496 | POINT (-73.9394955 40.81020941) |
| 27310 | 246876579 | 06/19/2022 | 20:08:00 | BRONX | INSIDE | 46 | 2.0 | HOUSING | MULTI DWELL - PUBLIC HOUS | False | 25-44 | M | BLACK | 25-44 | M | WHITE HISPANIC | 1012980.0 | 251028.0 | 40.855644 | -73.896141 | POINT (-73.896141 40.855644) |
| 27311 | 239861542 | 01/28/2022 | 18:14:00 | BRONX | OUTSIDE | 45 | 0.0 | STREET | (null) | False | 18-24 | M | BLACK | 18-24 | M | BLACK | 1026549.0 | 244293.0 | 40.837102 | -73.847134 | POINT (-73.847134 40.837102) |